package com.yf1706.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.yf1706.bean.SalaryDetail;
import com.yf1706.vo.SalaryDetailVO;

public interface ISalaryDetailJDAO extends JpaRepository<SalaryDetail, Integer>{

	@Query("select new com.yf1706.vo.SalaryDetailVO(s.salaryDetailsId, s.emp.empId,"
			+ " s.emp.empName, s.salaryItem, s.salaryItemValue) from "
			+ "SalaryDetail s where s.salary.salaryId = ?1")
	List<SalaryDetailVO> fingBysalaryId(int Sid);
}
